{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Template","Instructions","Sheet1","Equipment"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Template","index":0,"n_rows":69,"n_cols":23,"rows_kept":69,"cut":false,"hidden":false,"merged":[[3,13,3,15],[43,16,43,17],[44,16,44,17],[66,16,66,17],[43,18,43,19],[44,18,44,19],[66,18,66,19],[43,20,43,21],[44,20,44,21],[66,20,66,21],[15,1,15,15],[66,6,66,7],[66,10,66,11],[66,12,66,13],[64,2,64,3],[65,2,65,3],[66,4,66,5],[56,2,56,3],[57,2,57,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[54,2,54,3],[55,2,55,3],[44,1,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[66,14,66,15],[44,10,44,11],[44,12,44,13],[44,14,44,15],[51,2,51,3],[52,2,52,3],[53,2,53,3],[66,8,66,9],[61,2,61,3],[63,2,63,3],[41,1,41,2],[41,7,41,12],[41,13,41,14],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[43,12,43,13],[43,14,43,15],[39,1,39,2],[39,7,39,12],[39,13,39,14],[40,1,40,2],[40,7,40,12],[40,13,40,14],[37,1,37,2],[37,7,37,12],[37,13,37,14],[38,1,38,2],[38,7,38,12],[38,13,38,14],[32,13,32,14],[36,1,36,2],[36,7,36,12],[36,13,36,14],[33,1,33,2],[31,7,31,12],[31,13,31,14],[34,1,34,2],[33,7,33,12],[33,13,33,14],[30,25,30,27],[30,28,30,29],[28,19,28,24],[28,25,28,27],[28,28,28,29],[29,1,29,2],[29,7,29,12],[29,13,29,14],[29,19,29,24],[29,25,29,27],[29,28,29,29],[30,7,30,12],[30,13,30,14],[30,1,30,2],[26,19,26,24],[26,25,26,27],[26,28,26,29],[27,19,27,24],[27,25,27,27],[27,28,27,29],[24,1,24,15],[24,19,24,24],[24,25,24,27],[24,28,24,29],[25,1,25,15],[25,19,25,24],[25,25,25,27],[25,28,25,29],[22,19,22,24],[22,25,22,27],[22,28,22,29],[23,1,23,15],[23,19,23,24],[23,25,23,27],[23,28,23,29],[18,1,18,15],[20,1,20,11],[20,19,20,24],[20,25,20,27],[20,28,20,29],[21,1,21,15],[21,19,21,24],[21,25,21,27],[21,28,21,29],[10,16,10,18],[11,1,11,2],[11,4,11,7],[6,4,6,5],[6,13,6,15],[7,4,7,5],[7,6,7,9],[7,10,7,11],[8,4,8,5],[8,6,8,11],[8,12,8,13],[8,14,8,15],[9,4,9,5],[9,6,9,10],[9,11,9,13],[9,14,9,15],[1,4,2,10],[4,12,4,13],[4,14,4,15],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,15],[49,2,49,3],[50,2,50,3],[12,1,12,15],[13,1,13,15],[14,1,14,15],[17,1,17,15],[16,1,16,15],[22,1,22,15],[26,1,26,15],[31,1,31,2],[34,7,34,12],[34,13,34,14],[32,1,32,2],[35,7,35,12],[35,13,35,14],[35,1,35,2],[32,7,32,12]]}
[]
[null,null,null,null,"University of Utah - 2218",null,null,null,null,null,null,null,null,"Daily Job Journal  "]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Date"]
[null,null,null,null,"Record of Project Observation"]
[null,null,null,null,"Probst Job No. ",null,2218,null,"Project Name:"]
[null,null,null,null,"Day/Date: ",null,"S","M","T","W","TH","F","S"]
[null,null,null,null,"Weather:",null,null,null,null,null,"Temperature:",null,"Min",null,"Max"]
[null,null,null,null,"Conditions:",null,null,null,null,null,null,null,"Contractor:"]
[null,null,null,null,"Delay/Reason:",null,null,null,null,null,null,"Superintendent Present:"]
[]
[null,"Work in Progress "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Points of Interest, Subcontractors, Scope Changes"]
[]
[]
[]
[]
[null," "]
[]
[]
[null,"Job Codes",null,null,null,null,null,"Equipment"]
[null,"Description",null,"ACTIVITY CODE#","Hours",null,null,"Description",null,null,null,null,null,"Unit #",null,"Hrs\nUsed"]
[null,"SAFETY / QA-QC",null,950,{"$f":"E67","v":30},null,null,"PICKUP     Greg Avarrett",null,null,null,null,null,3003,null,{"$f":"W47","v":10}]
[null,"TEMPORARY WORK & FENCING",null,1920,{"$f":"G67","v":30},null,null,"PICKUP      Ryker Sweat",null,null,null,null,null,4229,null,{"$f":"W48","v":10}]
[null,"DUCTBANK",null,1930,{"$f":"I67","v":0},null,null,"PICKUP      Troy Klungervik",null,null,null,null,null,3156,null,8]
[null,"MEDIUM VOLTAGE WIRE",null,1940,{"$f":"K67","v":65},null,null,"PICKUP      Rex Mitchell",null,null,null,null,null,3165,null,10]
[null,"MANHOLES",null,1960,{"$f":"M67","v":8},null,null,"PICKUP     Lance Ames",null,null,null,null,null,3166,null,10]
[null,"SECONDARY SERVICES (BLDGS)",null,1970,{"$f":"O67","v":0},null,null,"PICKUP      Kelly Hortin",null,null,null,null,null,3149,null,{"$f":"W52","v":10}]
[null,"DEMOLITION",null,1900,{"$f":"Q67","v":0},null,null,"PICKUP"]
[null,"MEDIUM VOLTAGE EQUIPMENT",null,1950,{"$f":"S67","v":0},null,null,"FORKLIFT",null,null,null,null,null,"sunbelt"]
[null,"PROJECT SUPERVISION",null,1000,{"$f":"U67","v":0},null,null,"DIGGER DERRICK TRUCK"]
[null,null,null,null,null,null,null,"DELIVERY TRUCK"]
[null,null,null,null,null,null,null,"WIREBOAT"]
[null,null,null,null,null,null,null,"BACKHOE"]
[]
[null,"Labor",null,"Phase Code",100,null,100,null,100,null,100,null,100,null,100,null,100,null,100,null,100]
[null,"Activity Code",null,null,{"$f":"D31","v":950},null,{"$f":"D32","v":1920},null,{"$f":"D33","v":1930},null,{"$f":"D34","v":1940},null,{"$f":"D35","v":1960},null,{"$f":"D36","v":1970},null,{"$f":"D37","v":1900},null,{"$f":"D38","v":1950},null,{"$f":"D39","v":1000}]
[null,"Employee Name","Classification",null,"ST","OT","ST","OT","ST","OT","ST","OT","ST","OT","ST","OT","ST","OT","ST","OT","ST","OT","Total Hrs"]
[null,"Greg Avarrett","Superintendent",null,null,null,0,"N",null,null,10,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F47:V47)","v":10}]
[null,"Ryker Sweat","Journerymen",null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F48:V48)","v":10}]
[null,"Troy Klungervik","Journerymen Lineman",null,null," "," "," ",null,null,null,null,8,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E49:V49)","v":8}]
[null,"Rex Mitchell","Safety / QA-QC",null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,"Lance Ames","Journeymen",null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,"Kelly Hortin","Journeymen",null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,"Wacey Sweat","Apprentice",null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,"Eric Stephenson","Apprentice",null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,"Scott Lindsey","Labor",null,null," ",10," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,"Keno Mecham","Labor",null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Jaren Sharp","Labor",null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Austin Erickson","Materials Handler",null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[null,"Devon Thacker","Labor",null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[null,"Madison Smith","Apprentice",null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[null,"Chad Montean","Labor",null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[]
[]
[]
[]
[null,null,null,"QTY TOTALS",{"$f":"SUM(E47:F66)","v":30},null,{"$f":"SUM(G47:H66)","v":30},null,{"$f":"SUM(I47:J66)","v":0},null,{"$f":"SUM(K47:L66)","v":65},null,{"$f":"SUM(M47:N66)","v":8},null,{"$f":"SUM(O47:P66)","v":0},null,{"$f":"SUM(Q47:R66)","v":0},null,{"$f":"SUM(S47:T66)","v":0},null,{"$f":"SUM(U47:V66)","v":0},null,{"$f":"SUM(E67:N67)","v":133}]
[]
[null,null,null,null,null,null,null,"Signature"]

{"sheet":"Instructions","index":1,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["This form is available for employees of Probst Electric to fill out concerning daily labor."]
[]
[1,"Enter in date in the user form that appears initially."]
[2,"Adjust weather and related conditions."]
[3,"Enter in work progress information in user form opened by the Work in Progress Button."]
[4,"Enter other points of interest."]
[5,"If needed use the add/delete employee command buttons for editing employees."]
[6,"Enter employee hours under the Labor portion. This data will then be totaled and fill in Job and Equipment hours."]

{"sheet":"Sheet1","index":2,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Superintendent","Journeymen","Apprentice","Labor","Lineman"]
["Journeymen"]
["Apprentice"]
["Labor"]
["Lineman"]

{"sheet":"Equipment","index":3,"n_rows":82,"n_cols":14,"rows_kept":82,"cut":false,"hidden":true,"merged":[[76,1,76,4],[75,1,75,4],[74,1,74,4],[73,1,73,4],[72,1,72,4],[76,5,76,6],[75,5,75,6],[74,5,74,6],[73,5,73,6],[72,5,72,6],[82,5,82,6],[80,5,80,6],[79,5,79,6],[78,5,78,6],[77,5,77,6],[81,5,81,6],[82,1,82,4],[80,1,80,4],[79,1,79,4],[78,1,78,4],[77,1,77,4],[81,1,81,4],[2,12,2,13],[66,5,66,6],[71,1,71,4],[70,1,70,4],[2,10,2,11],[69,5,69,6],[68,5,68,6],[67,5,67,6],[69,1,69,4],[68,1,68,4],[67,1,67,4],[66,1,66,4],[71,5,71,6],[70,5,70,6]]}
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Week Ending",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
["Internal Equipment"]
["Unit #","Year","Make","Model","License Plate #","VIN or Serial #","Description","Sun.","Mon.","Tues.","Wed.","Thurs.","Fri.","Sat."]
[300,2007,"Chevy",3500,null,"1GCJK33D77E155926","4X4"]
[303,1994,"Chevy",2500,null,"1GCGK29K8RE180904"]
[304,1993,"Chevy",3500,null,"1GCHK34K1PE135916"]
[305,1999,"Chevy",2500,null,"1GCGK29U0XE251494"]
[306,1981,"GMC",3500,null,"1GTHK33M6BZ511398","Crew Cab"]
[307,2006,"Ford","F350",null,"1FTWW31P26EB86285","Crew Cab"]
[308,2006,"Ford","F350",null,"1FTWX31P46EB77763","Extra Cab"]
[309,2007,"GMC",3500,null,"1GCHK33D57F174313","K Series 4X4 Crew Cab"]
[315,2000,"Ford","F450",null,"1FDXF46F4YED90711","Utility Bed 4X2"]
[316,2003,"Ford","F150",null,"2FTRF18W13CA83777","4X4 Short Bed"]
[401,1979,"International",null,null,"AX195JCA20012","Line Truck"]
[402,1979,null,"AMGN",null,"NL06VSC22810675","6X6 Army Bunk Truck"]
[403,2001,"International",4700,null,"1HTSCABN31H333247","IHC 4X2 4700 Bucket Truck"]
[404,2001,"International",4700,null,"1HTSCABNX1H333259","IHC 4X2 4700 Bucket Truck"]
[405,1998,"Western Star","4900E",null,"2WKPDCCJ0WK951168","6X4 Constellation Semi Truck"]
[406,1998,"International",null,null,"1HTSCABN2WH554507","4X2 \"4000\" Series"]
[407,1972,null,"XM818",null,"05D67170C12412068","5 Ton 6X6 Utility Truck"]
[408,1992,"Volvo",null,null,"4V2SCBJH5MU507899","Dump Truck"]
[409,1999,"Freightliner",null,null,"1FUWHLBB6XH966988","Water Truck 4X2 106\" BBC Conv"]
[501,2007,"Big Tex",null,null,"16VGX202X72648987","Trailer"]
[502,2005,null,"49092P",null,"5C3HH302651007502","Flatbed Trailer-Jamies Weld"]
[503,2005,"Wagner Smith",null,null,"1W9MP1824YB161141","4 Drum Puller"]
[505,1996,"TSE","11982R",null,"1T91S0526TS268419","Tensioner / Reel Carrier"]
[506,1989,null,"96358P",null,"1GRAA5615KB004606","Box Van Trailer"]
[508,2007,"Big Tex",null,null,"16VPX162872374934","Utility 16' Pipe Trailer"]
[510,1963,null,"007158Z",null,214147,"Comm Trim Trailer-Container"]
[511,1981,null,"11887R",null,"P250781281","Comm Trim AMEB Trailer"]
[512,2007,"Pace American","802UXR",null,"4P2UB14247U085279","Trailer"]
[513,1983,null,"691UXT",null,"1BUP20101D1001868","Butler Pole Trailer"]
[514,1973,null,"692UXT",null,10052,"Lela 38' Semi Trailer"]
[515,1999,"Fontaine",71132,null,"13N4482C0X1588316","48' Expandable Trailer"]
[516,1980,null,"171UYN",null,"194527M","Budd Dry Van Trailer"]
[517,1984,null,null,null,"0000000517","Orange Reel Carrier"]
[518,1987,null,null,null,"0000000518","Red Reel Carrier"]
[519,1963,"Fruehoff","6007TD",null,6007,"Pole Trailer"]
[520,1997,"Baker","6008TD",null,6008,"Single Axel Reel Trailer"]
[521,1997,"Baker","6009TD",null,6009,"Double Axel Reel Trailer"]
[522,1977,"AMEB","007157Z",null,30151,"Comm Van Trailer"]
[523,1984,"Freuhauf",null,null,"1H2R04528EH074856","Van Trailer"]
[524,2001,"Wilson",null,null,"4WWFGB91N606331","3 Exel Stepdeck Trailer"]
[525,1995,"Towms",null,null,"4KNFT2023SL161241","Backhoe Trailer"]
[526,2008,"Interstate",null,null,"4RACS1822N061803","Enclosed Hot Stick Trailer"]
[527,2008,"SRTC","GNFB28-20K DT",null,"5PTGF352881011559","Snake River Flatbed-Goose neck Trlr"]
[601,1999,"Case","1845C",null,"SN: JAF0293849","Skid Steer Loader"]
[602,null,"Cat",305,null,"SN: DSA00589","Caterpiller 305 Mini-X"]
[603,2007,"Polaris","Ranger",null,"4XARF68A274391958","Ranger ATV"]
[604,1999,"Case",580,null,null,"Backhoe W/Beacon"]
[605,1999,"Case",580,null,"JJG0267678","Backhoe"]
[607,null,"John Deer","410E",null,"TO410EX886641","4WD Backhoe"]
[null,null,null,null,null,null,"Tank"]
[]
[]
["External Equipment"]
["Unit #","Description",null,null,null,"Vendor",null,"Sun.","Mon.","Tues.","Wed.","Thurs.","Fri.","Sat."]
["94-4744236","Sterling-Crane Truck",null,null,null,"Global Equipment"]
["L-6825","Sterling Actera 6X6 Digger Derrick",null,null,null,"UELC-Lease"]
["L-6925","International 4X4 Digger Derrick",null,null,null,"UELC-Lease"]
[103240,"Cat Excavator 330D w/LoDrill  IM",null,null,null,"Black & Veatch"]
[9990,"2000 Atlas Copco ECM370 drill  IM",null,null,null,"Cate Equipment"]
[931,"Ford 4X4 Truck",null,null,null,"Tab Leasing - Jeremy"]
[930,"Ford 4X4 Truck",null,null,null,"Tab Leasing -  Birchs old truck"]
[4130,"International 4X2 Bucket",null,null,null,"UELC-RPO"]
["G0111917","Hogg Davis 404 Puller",null,null,null,"NESCO EQUIPMENT"]
["G0111350","Tensioner",null,null,null,"NESCO EQUIPMENT"]
["JRD 20","3 Drum Hardline Puller",null,null,null,"JRD Equipment"]
[1923,"International 6X6 Bucket Truck",null,null,null,"UELC-LEASE"]
["37-4606516","International 4X4 Bucket Truck",null,null,null,"Global Equipment"]
["JRD-14","Peterbuilt Crane Manitex",null,null,null,"JRD Equipment"]
[null,"Ford 25 Ton Crane",null,null,null,"ISC"]
[null,"Kenworth",null,null,null,"J Fleet Management"]